UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vVTXQEjR3WM+dqiz8fdErNQhAInAzzTA5lZvrjGiopw='
WHERE
key_id = 'c5b58828e4e5f258fafd64e09303de05c00dda166bf5d117a3a498ebe77d5f46'
AND (
token = 'vVTXQEjR3WM+dqiz8fdErNQhAInAzzTA5lZvrjGiopw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)