UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHzCK+YwxLPmfBbToBQT0TpmDG48TdQ36LJYyfaA4wI='
WHERE
key_id = '1bb6c39f415e65903a4719c28cd8bf5ba57cb6e2861a7cbe74fad51dd9fe0b7b'
AND (
token = 'pHzCK+YwxLPmfBbToBQT0TpmDG48TdQ36LJYyfaA4wI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)