UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2AL9mk+yKt/hpYQkIA75euZvQeuMYTaIDX0MVnC2vfw='
WHERE
key_id = '0e78f0bf7b8fb42a0cfd15f1cdc505abf10408a7590c26e0065bd7516b960f10'
AND (
token = '2AL9mk+yKt/hpYQkIA75euZvQeuMYTaIDX0MVnC2vfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)