UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tFSHC84t4iR44S0XP+1B5YbYy1RLVaNWpEFbk1bx4Mw='
WHERE
key_id = 'c9bafbc29a1fab8c990792da3429cad6edc02d5957e431d32e4668c85eff100d'
AND (
token = 'tFSHC84t4iR44S0XP+1B5YbYy1RLVaNWpEFbk1bx4Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)