UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TktDGTvQ6qgbThkplyPf709n+7FHxu7KYYG/5J+VUC0='
WHERE
key_id = 'd012e7c3e4b7fd688541e0d5e1237f5634728d5d7070ee24504385413091d4d8'
AND (
token = 'TktDGTvQ6qgbThkplyPf709n+7FHxu7KYYG/5J+VUC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)