UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dcWv6tN5U0J19t1e3zkTsgB/eAoS1KKWCjbUk2gOa20='
WHERE
key_id = 'b12aa23f6a97d045823deee3311fcbdfab87a9b00ea4e5c6e09306651c09f929'
AND (
token = 'dcWv6tN5U0J19t1e3zkTsgB/eAoS1KKWCjbUk2gOa20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)