UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJ1WHi1E6p8lo39ksbRB7TYK0HSZSiyjfgZ05nsdCZ0='
WHERE
key_id = '12138451e28ee78f0df7d55b4fb9b4be40fc54c6aaaea084ac365c20a5926459'
AND (
token = 'DJ1WHi1E6p8lo39ksbRB7TYK0HSZSiyjfgZ05nsdCZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)