UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9aAqRbu+CsmAwiHp4+msNQw7iUo7e4K15xbWMV5Kphs='
WHERE
key_id = 'c6fe977d14541f257a0071cb2b300991aa2227492cbe0796de9c1d4aa3e607cb'
AND (
token = '9aAqRbu+CsmAwiHp4+msNQw7iUo7e4K15xbWMV5Kphs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)