UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jcpWoAMUFwro5fYADSg1s37f6u4Phjn5C7bmY7Plzr8='
WHERE
key_id = '842b5b3beff7470ce1029936184e6e6eb942dfdc02de5f0dc2687c5874842d6f'
AND (
token = 'jcpWoAMUFwro5fYADSg1s37f6u4Phjn5C7bmY7Plzr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)