UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A/ps4mQZzR7sltkLHaOVXS8XdigmFj4f3rcGBRusmIs='
WHERE
key_id = 'bdc0ed21cf2d69822a91dff6fd4b26969920a0263195036bfa7f3e6511861207'
AND (
token = 'A/ps4mQZzR7sltkLHaOVXS8XdigmFj4f3rcGBRusmIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)