UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AMJKFOJhlaOguKlZLz5Jcj/0AqGIBfUPpeBxmamuVTU='
WHERE
key_id = 'a65ebfb31c50cd6bf69864e4c6f86a76da272a41f227acc65d6ed31ee15739bc'
AND (
token = 'AMJKFOJhlaOguKlZLz5Jcj/0AqGIBfUPpeBxmamuVTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)