UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TxUeOZrPQb/vEsP37C16jqIX661RZC00pPY777aDRKE='
WHERE
key_id = 'bfc5ed9ddce70387c58bcd506c94223e103b5606e4be6fef6fc16a270be03c57'
AND (
token = 'TxUeOZrPQb/vEsP37C16jqIX661RZC00pPY777aDRKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)