UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C29y+qffR1AnHVUv3gsFnJ0vvUyyWUXHF5ARcwB+L88='
WHERE
key_id = 'db886800b407fd2979971c22d100742c01e8486bd20605c55e8e0481e034ab67'
AND (
token = 'C29y+qffR1AnHVUv3gsFnJ0vvUyyWUXHF5ARcwB+L88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)