UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6oYlctvWfhixUY0PcStmGVUSFUgDi/+J1rPVcZCxFTE='
WHERE
key_id = '6686dee86b29f847d333a2ce88237e8815f751cd5a42c98c13fa2f5ebe1d749a'
AND (
token = '6oYlctvWfhixUY0PcStmGVUSFUgDi/+J1rPVcZCxFTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)