UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TJRnnKMDvp6tPGj9kHwHAgAwkGZVn9/MD4C2Efq1otk='
WHERE
key_id = 'b21757ebd13818ac3e30db09c29320f06f89774ae0904c4373f9ff5de22eeaa5'
AND (
token = 'TJRnnKMDvp6tPGj9kHwHAgAwkGZVn9/MD4C2Efq1otk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)