UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGsIUueWqPQKO2EiFRs80aAZnXcbyAASJpsFE3QH2c4='
WHERE
key_id = '08813224f2fd62a3d03a9bb01a90b12a85799b94efe3c57f58972c73f0ec3c7f'
AND (
token = 'CGsIUueWqPQKO2EiFRs80aAZnXcbyAASJpsFE3QH2c4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)