UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5lOJlSmosMw6MAIn6l30xgMx4tJKmTPmifM1EDj70Qw='
WHERE
key_id = 'd1504c5f1fb744bf25c569216ef8ffb9e2f37816569adcaeb28b9b21ad840fac'
AND (
token = '5lOJlSmosMw6MAIn6l30xgMx4tJKmTPmifM1EDj70Qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)