UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EvNc+tLzNp8p7i++SeZmm3a/0WYOMdXC7DCeJccxnvY='
WHERE
key_id = '93c8971651f289d1ef92e5d27de65c2b8940dde31a56cc746cc44db451117709'
AND (
token = 'EvNc+tLzNp8p7i++SeZmm3a/0WYOMdXC7DCeJccxnvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)