UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k1jSZjqQIcZMBVwTHQHZhDU2cA17AulTElg1s4tLoHE='
WHERE
key_id = 'ce200bd9f8d8797446da9b0eae2d4866a01cc41c594d30d8acad8d19d7631150'
AND (
token = 'k1jSZjqQIcZMBVwTHQHZhDU2cA17AulTElg1s4tLoHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)