UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jgpDk/9TnZpmwSlx45fJadsJCiGbD8Mym+iFXfGYrC8='
WHERE
key_id = '7d511b0722e969d63eb725dd0a5ab28473ca7fb655bff5ef265eb8177a3730d6'
AND (
token = 'jgpDk/9TnZpmwSlx45fJadsJCiGbD8Mym+iFXfGYrC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)