UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1gF3QLOxrG8/m7li59iA5UI6eQAx6gwxw/FCSoEt/4w='
WHERE
key_id = 'e2c337e0bf37a3c7cb573cf7f975ae0c8f7f1f55bd2f40d618c069842ed1b0b2'
AND (
token = '1gF3QLOxrG8/m7li59iA5UI6eQAx6gwxw/FCSoEt/4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)