UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GoHbyDCPnDF1bah82FemCbKOCl5zo8IHz2W91se+zvM='
WHERE
key_id = '20aeb83d9f75baf9ce1393bad77c4f501bfdc15619f96db9465a366b85571ade'
AND (
token = 'GoHbyDCPnDF1bah82FemCbKOCl5zo8IHz2W91se+zvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)