UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qr+NZw34v9KBTs/OK9BUjIMtaJ2vVqIL5Qkj6xONc98='
WHERE
key_id = 'b6be66e972eacf124ec096974121b5b0c0c16dd490c3e740638bd16f6dbf0f8a'
AND (
token = 'Qr+NZw34v9KBTs/OK9BUjIMtaJ2vVqIL5Qkj6xONc98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)