UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rox+P1WZv/QRAZHLh/RlH9plnv1bA+naErmKLbW23wg='
WHERE
key_id = 'e999ce465a848640c23f1673fc13fe23e560b0f3be8aa8cbf9aef97a63826fe9'
AND (
token = 'rox+P1WZv/QRAZHLh/RlH9plnv1bA+naErmKLbW23wg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)