UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBg0fT+j19freK0OTVwX/+FjciFoKCVgZ3Alu4Q2ERY='
WHERE
key_id = 'dcf3742f5185c9ecc33a50cc8ddc2ac78fc429ec44143d6fcaef5a70b56c40cd'
AND (
token = 'pBg0fT+j19freK0OTVwX/+FjciFoKCVgZ3Alu4Q2ERY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)