UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YyCGkP4jGvTJe8QsVh9ilxZCIsvStwUzjJ76P9tpyQ8='
WHERE
key_id = '5232d33570f53d4f7e397d972bb81b2506c6785e6c20493ac0e7d62b48a58af1'
AND (
token = 'YyCGkP4jGvTJe8QsVh9ilxZCIsvStwUzjJ76P9tpyQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)