UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QnwUh2MYMNaz0m7QEJtyITck28UpJdPmDnFQPJI+vTg='
WHERE
key_id = 'ed40f0763f45caff467f5e499f7a8acd72ebbb2cc3d2e9c2c1f664bfe8dfa886'
AND (
token = 'QnwUh2MYMNaz0m7QEJtyITck28UpJdPmDnFQPJI+vTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)