UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V+A2ldsUth3zGfWKjBih65tJqJ8rWw93UQP2ul67lJQ='
WHERE
key_id = '9563240982d943cd817ee4b827d6ec870f8e9977ebe8669f5e5e85784ce9b7b2'
AND (
token = 'V+A2ldsUth3zGfWKjBih65tJqJ8rWw93UQP2ul67lJQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)