UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kXf9cYdbIM7yjX2iSuyI4o5lghHkCIXgCvNGnOa4Xgo='
WHERE
key_id = '05f6563c3e2d903ac9741e961de01c40afe71129ab4869735398262d4ee23a7c'
AND (
token = 'kXf9cYdbIM7yjX2iSuyI4o5lghHkCIXgCvNGnOa4Xgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)