UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PDgcfBZqSZINWjduQU7lYHfEWX5aik+J8inRWoQYWe4='
WHERE
key_id = 'bc3e940e78c658e0fb3d104c320e23586d1075d02185b3fa50afb75937d74c05'
AND (
token = 'PDgcfBZqSZINWjduQU7lYHfEWX5aik+J8inRWoQYWe4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)