UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7v+CpLmmzOzIfmzqpaSFk6+gln3xos84Nb4oCBFyRUw='
WHERE
key_id = '4ac817b50a7d5da6b682db5cdfe57c17a3a0c2da2dcbd5eb5b2f685f4c314f2c'
AND (
token = '7v+CpLmmzOzIfmzqpaSFk6+gln3xos84Nb4oCBFyRUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)