UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oKzCvRrIbBHr92jmlVN71O98GihwFa1dUyaQPuODVtI='
WHERE
key_id = '20f9828ed366bf130ff8ec49cccdde8261d81dfde6c8a8cd6e1f6968accf1d0a'
AND (
token = 'oKzCvRrIbBHr92jmlVN71O98GihwFa1dUyaQPuODVtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)