UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZPwU3ahCCpmhY7S69oMkzFCk9BOKgKvRIIt9rccCfI='
WHERE
key_id = '891f3243fb1b5f7be42c91f94f3cfcebce4bd25c579cede12beafafa38047a66'
AND (
token = 'qZPwU3ahCCpmhY7S69oMkzFCk9BOKgKvRIIt9rccCfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)