UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zk+gKh2QYXB4nZTOIIgJm+DCZszFZmOlMlVzoja0oZI='
WHERE
key_id = '8fef4ece1442a416d15fb9bb7780b4f8003c031406dfecde2cac225e847d2df9'
AND (
token = 'Zk+gKh2QYXB4nZTOIIgJm+DCZszFZmOlMlVzoja0oZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)