UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NRH5Or6TfCHs32XgK1kexFZzu6sUXAp/GnJ4iww+uGs='
WHERE
key_id = '5f49cbede5ad2f03a709666a806bdb12878b06cc31b43c722c0299403a47967a'
AND (
token = 'NRH5Or6TfCHs32XgK1kexFZzu6sUXAp/GnJ4iww+uGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)