UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vWIpuoqGj6YBxIr5LDTvR7ZyjHAwe26zyeJQYbEpL40='
WHERE
key_id = 'a54d6569cc8ab757d6ff05451967732130495b40303fa9c59d265457656a97d0'
AND (
token = 'vWIpuoqGj6YBxIr5LDTvR7ZyjHAwe26zyeJQYbEpL40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)