UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DKVZUUewpHcYy+0c2z/2TUVxWVIfX/KCAuzj95KEGA4='
WHERE
key_id = '05bcd63ef83ac3fa75a5f024d8965933beb400b6859442d9ec8ef21b1e5ad0c9'
AND (
token = 'DKVZUUewpHcYy+0c2z/2TUVxWVIfX/KCAuzj95KEGA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)